<?php
$drop_tables = "drop table if exists qr_members, qr_data; ";

$create_member_table = "create table qr_members ( ";
$create_member_table .= "`id` int(10) not null auto_increment, ";
$create_member_table .= "`username` varchar(16) not null, ";
$create_member_table .= "`userpass` varchar(32) not null, ";
$create_member_table .= "`CDATE` DATE DEFAULT '0000-00-00', ";
$create_member_table .= "`LDATE` DATE DEFAULT '0000-00-00', ";
$create_member_table .= "`rootuser` char(1), ";
$create_member_table .= "primary key(`id`))DEFAULT CHARSET=utf8;";

$create_data_table = "create table qr_data ( ";
$create_data_table .= "`SEQNO` int(10) not null DEFAULT '0', ";
$create_data_table .= "`OLDSI` varchar(50) not null, ";
$create_data_table .= "`OLDGU` varchar(20) not null, ";
$create_data_table .= "`OLDDONG` varchar(50) not null, ";
$create_data_table .= "`OLDBUNJI` varchar(50) not null, ";
$create_data_table .= "`NEWSI` varchar(50) not null, ";
$create_data_table .= "`NEWGU` varchar(20) not null, ";
$create_data_table .= "`NEWDONG` varchar(50) not null, ";
$create_data_table .= "`NEWBUNJI` varchar(50) not null, ";
$create_data_table .= "`USED` varchar(50), ";
$create_data_table .= "`UNIT` varchar(50), ";
$create_data_table .= "`CPIC` varchar(255), ";
$create_data_table .= "`CDATE` DATE DEFAULT '0000-00-00', ";
$create_data_table .= "`LAT` varchar(30) not null, ";
$create_data_table .= "`LNG` varchar(30) not null, ";
$create_data_table .= "`PNG` varchar(255) not null, ";
$create_data_table .= "`TMP01` varchar(255), ";
$create_data_table .= "`TMP02` varchar(255), ";
$create_data_table .= "`TMP03` varchar(255), ";
$create_data_table .= "`TMP04` varchar(255), ";
$create_data_table .= "`TMP05` varchar(255), ";
$create_data_table .= "`TMP06` varchar(255), ";
$create_data_table .= "`TMP07` varchar(255), ";
$create_data_table .= "`TMP08` varchar(255), ";
$create_data_table .= "`TMP09` varchar(255), ";
$create_data_table .= "`TMP10` varchar(255), ";
$create_data_table .= "primary key(`SEQNO`))DEFAULT CHARSET=utf8;";
?>